---
title: clsClaimWorkStatus
summary: API reference for clsClaimWorkStatus.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# clsClaimWorkStatus

`clsClaimWorkStatus` owns a return-to-work status history row for a claim, hard-coding the initial work-status code on insert and retrieving only the latest row via a correlated `max(seq)` subquery.

## Purpose
- Provides full create/retrieve/update/delete of work-status rows ([SQL-003](../../sql/SQL-003.md), [SQL-007](../../sql/SQL-007.md), [SQL-021](../../sql/SQL-021.md), [SQL-045](../../sql/SQL-045.md), [SQL-060](../../sql/SQL-060.md)).
- Enforces that the work-status date is not later than the current date ([BR-003](../../business-rules.md#br-003-work-status-date-cannot-be-in-the-future)).

## Context
- Namespace: `SAIF.Business.Claim`
- Assembly/package: `SAIF.Business.Claim.dll`

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `Criteria.InsertSQL` | `ReadOnly Property InsertSQL As String` | Inserts a new row with `WORK_STATUS_CODE` hard-coded to `'1'` ([SQL-007](../../sql/SQL-007.md)). |
| `Criteria.RetrieveSQL` | `ReadOnly Property RetrieveSQL As String` | Retrieves only the latest work-status row via a correlated `max(seq)` subquery ([SQL-021](../../sql/SQL-021.md)). |
| `Criteria.UpdateSQL` | `ReadOnly Property UpdateSQL As String` | Updates the effective date using a `:UpdateNum + 1` increment form that differs from the `UPDATE_NUM + 1` form used elsewhere in the library ([SQL-045](../../sql/SQL-045.md)).* |
| `ValidWorkStatusDate` | `Public Function ValidWorkStatusDate() As Boolean` | Enforces [BR-003](../../business-rules.md#br-003-work-status-date-cannot-be-in-the-future). |

## Behavioral notes
- DB-contention errors are raised via `After*` hooks on insert/update/delete ([BR-012](../../business-rules.md#br-012-optimistic-concurrency-contention-check)).

## Constraints and usage notes
- Only the most recent work-status row per claim is retrievable through this object; full history requires a separate query.

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Related documentation
- [Library index](../../index.md)
- [API reference index](../index.md)
- [Overview](../../overview.md)
- [Architecture](../../architecture.md)
- [Dependencies](../../dependencies.md)
- [Operations and processes](../../operations-processes.md)
- [Business rules](../../business-rules.md)
- [Database tables](../../database-tables.md)
- [SQL catalog](../../sql/index.md)
## Sources
- SAIF.Business.Claim/clsClaimWorkStatus.vb